package com.ruoyi.web.dao;

import com.ruoyi.web.model.ContributionData;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface DashboardMapper {
    @Select("select count(*) from sys_article")
    Integer getArricleCount();

    @Select("select count(*) from user")
    Integer getUserCount();

    @Select("select count(*) from sys_message")
    Integer getMessageCount();

    @Select("select sum(quantity) from sys_article")
    Integer getVisitCount();


    List<ContributionData> getContributionData();

    List<Map<String, Integer>> getBottomData();


    List<Integer> getBrowseTrendDatabyWeek();

    List<Integer> getBrowseTrendDatabyMonth();
}
